Decimal lost when settings were changed to integer due to rounded off.
Cause:
When a field's property settings are changed from Decimal Number to Integer Number, Access automatically rounds the decimals to the nearest whole number.
NOTE: These settings are changed when the number of decimals is changed in the 'Decimal Places' property box in the 'Field Properties' section of the Table Design window.
Solution:
Change the settings back to Decimal Number, and re-enter any data that was lost.
1) If the Database window is not active, activate the Database window.
2) Go to the table's Design view.
3) Select the field where decimals were lost.
4) Move to the 'Field Properties' section.
Field Properties section
5) Click the 'General' tab.
6) Single-click in the 'Decimal Places' property box. (A down arrow appears in the right of the box.)
7) Click on the arrow in the 'Decimal Places' property box. (A drop-down list appears.)
8) Select the desired number of decimal places from the drop-down list box.
Decimal Places
9) Select the 'File' menu and select 'Save' to save the changes.
10) (Optional) If the decimals did not return:
11) Select the 'File' menu and select 'Close' to close the Table Design or Table Datasheet window.
